Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL IDXACTIVATE qualifier

Activates an inactive index.

Syntax

proutil db-name -C idxactivate [owner-name.]table-name.index-name           [useindex table-name.index-name] [recs n] [refresh t]

Parameters

db-name

Specifies the database containing the index being activated.

[owner-name.]table-name.index-name

Specifies the index being activated. You must specify the table and index names. Specify the owner name if tables in your database have more than one owner.

useindex table-name.index-name

Specifies an index to use to while accessing the records in your table to build the index being activated. This index must be active. If you omit this parameter, the primary index will be used.

recs n

Specifies the number of records to process in one transaction. If you omit this parameter, IDXACTIVATE will process 100 records per transaction by default.

refresh t

Specifies the frequency in seconds to update the display of clients that are blocking the index activation. The default refresh rate is 60 seconds. You can set it as high as 300 seconds. Connected clients with a schema timestamp earlier than the index’s schema timestamp will prevent activation of the index.

Notes

IDXACTIVATE works for both online and offline databases.
If IDXACTIVATE detects clients with an earlier schema timestamp than the index, you may wait for those clients to disconnect or forcibly disconnect them with PROSHUT. The index cannot be activated until those clients are disconnected from the database.
You cannot activate indexes on schema or auditing tables with IDXACTIVATE.